SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 46806: Authorization error might occur when opening an information map table in SAS® Enterprise Guide® or the SAS® Add-In for Microsoft Office

DetailsHotfixAboutRate It

When opening an information map in SAS Enterprise Guide or the SAS Add-In for Microsoft Office, you might see the following error:

ERROR: The GET routine failed to fetch data from the cursor. 
ERROR: User not authorized to access data source for information map. 

This error is most likely to appear if you are running SAS® 9.3 or 9.3_M1.

Beginning in SAS 9.3, Read permission is required on the table that is being used as the input data source (table) for the information map. For example, say that you have an information map named "Student Data". The input data source for that information map might be the CLASS table in the SASHELP library. The user who is logged into SAS Enterprise Guide or the SAS Add-In needs Read permission specifically on the CLASS table.

There are three ways to resolve this issue:

  • If you are running 9.3_M1, you can install the two hot fixes that are available from the Hot Fix tab in this SAS note.
  • You can install maintenance 2 for SAS 9.3. For more information, see Maintenance Releases and Product Upgrades.
  • You can use SAS® Management Console to navigate to the table and grant explicit Read permission to the users or groups who need to open the information map in SAS Enterprise Guide or the SAS Add-In.
  • Note: If the pooled workspace server is being used to access the information map, then you must make sure that the launch credentials used for the pooled workspace server are given Read permission to the table. For example, the pooled workspace server is used if the logged in user does not have operating system permissions to the underlying table.

Change in behavior from SAS 9.2

In SAS 9.2, you could perform the following tasks to restrict access to data based on identity.

  1. Create an information map with identity-driven, row-level permissions.
  2. Register the information map as a table in metadata.
  3. Open the filtered information map table in SAS Enterprise Guide or the SAS Add-In for Microsoft Office.

You achieved this result by denying Read permission to the table used as input to the information map. After upgrading to SAS 9.3, this solution no longer works. You must use one of resolutions in this SAS Note to regain the functionality from SAS 9.2



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASSolaris for x649.3 TS1M09.3 TS1M2
Linux for x649.3 TS1M09.3 TS1M2
Linux9.3 TS1M09.3 TS1M2
HP-UX IPF9.3 TS1M09.3 TS1M2
Windows 7 Enterprise x649.3 TS1M09.3 TS1M2
Windows 7 Enterprise 32 bit9.3 TS1M09.3 TS1M2
Microsoft Windows XP Professional9.3 TS1M09.3 TS1M2
Microsoft Windows Server 2008 for x649.3 TS1M09.3 TS1M2
Microsoft Windows Server 20089.3 TS1M09.3 TS1M2
Microsoft Windows Server 2003 for x649.3 TS1M09.3 TS1M2
Microsoft Windows Server 2003 Standard Edition9.3 TS1M09.3 TS1M2
Microsoft Windows Server 2003 Datacenter Edition9.3 TS1M09.3 TS1M2
Microsoft® Windows® for x649.3 TS1M09.3 TS1M2
64-bit Enabled Solaris9.3 TS1M09.3 TS1M2
64-bit Enabled HP-UX9.3 TS1M09.3 TS1M2
64-bit Enabled AIX9.3 TS1M09.3 TS1M2
Windows Vista for x649.3 TS1M09.3 TS1M2
Windows Vista9.3 TS1M09.3 TS1M2
Windows 7 Ultimate x649.3 TS1M09.3 TS1M2
Windows 7 Ultimate 32 bit9.3 TS1M09.3 TS1M2
Windows 7 Professional x649.3 TS1M09.3 TS1M2
Windows 7 Professional 32 bit9.3 TS1M09.3 TS1M2
Windows 7 Home Premium x649.3 TS1M09.3 TS1M2
Windows 7 Home Premium 32 bit9.3 TS1M09.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition9.3 TS1M09.3 TS1M2
z/OS9.3 TS1M09.3 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.